/*
 * igo: com.cctv.igo.security.common.Queries.java Create On 2011-4-28 下午10:15:04 By Q-Wang
 * $Revision: 1.1 $
 */
package com.ctvit.framework.security.common;

/**
 * @author <a href="mailto:apeidou@gmail.com">Q-Wang</a>
 *
 */
public class SecurityQueries {

	public static final String NS = "security.aclRelation.";
	/* User - Role */
	public static final String REMOVE_USER_ROLE_BY_USER = NS + "deleteUserRoleByUserId";
	public static final String REMOVE_USER_ROLE_BY_ROLE = NS + "deleteUserRoleByRoleId";
	public static final String REMOVE_USER_FROM_ROLE = NS + "removeUserFromRole";

	public static final String ADD_USER_TO_ROLE = NS + "addUserToRole";
	public static final String SELECT_ROLE_BY_USER = NS + "selectRoleByUser";

	public static final String SELECT_ALL_ROLE_BY_USER = NS + "selectAllRoleByUser";

	/* Group - Role */
	public static final String REMOVE_GROUP_ROLE_BY_ROLE = NS + "deleteGroupRoleByRoleId";
	public static final String REMOVE_GROUP_ROLE_BY_GROUP = NS + "deleteGroupRoleByGroupId";
	public static final String REMOVE_ROLE_FROM_GROUP = NS + "removeRoleFromGroup";

	public static final String ADD_ROLE_TO_GROUP = NS + "addRoleToGroup";
	public static final String SELECT_ROLE_BY_GROUP = NS + "selectRoleByGroup";
	public static final String SELECT_GROUP_BY_ROLE = NS + "selectGroupByRole";

	/* User - Group */
	public static final String REMOVE_USER_GROUP_BY_USER = NS + "deleteUserGroupByUserId";
	public static final String REMOVE_USER_GROUP_BY_GROUP = NS + "deleteUserGroupByGroupId";
	public static final String REMOVE_USER_FROM_GROUP = NS + "removeUserFromGroup";

	public static final String ADD_USER_TO_GROUP = NS + "addUserToGroup";
	public static final String SELECT_GROUP_BY_USER = NS + "selectGroupByUser";

	/* Role - Resource */
	public static final String REMOVE_ROLE_RESOURCE_BY_ROLE = NS + "deleteRoleResourceByRoleId";
	public static final String REMOVE_ROLE_RESOURCE_BY_RESOURCE = NS + "deleteRoleResourceByResourceId";
	public static final String REMOVE_RESOURCE_FROM_ROLE = NS + "removeResourceFromRole";

	public static final String ADD_RESOURCE_TO_ROLE = NS + "addResourceToRole";
	public static final String SELECT_RESOURCE_BY_ROLE = NS + "selectResourceByRole";
	public static final String UPDATE_ROLE_RESOURCE = NS + "updateRoleResource";

	public static final String SELECT_ROLE_DETAILS_BY_ROLE = NS + "selectRoleDetailsByRole";
	public static final String SELECT_ROLE_DETAILS = NS + "selectRoleDetails";
	public static final String SELECT_ROLE_DETAILS_BY_RESOURCE = NS + "selectRoleDetailsByResource";

	public static final String SELECT_ROLE_BY_RESOURCE = NS + "selectRoleByResource";

	/* Role,Group - User */
	public static final String SELECT_MANAGER_BY_ROLE = NS + "selectManagerByRole";
	public static final String SELECT_MANAGER_BY_GROUP = NS + "selectManagerByGroup";




}
